package com.dingding.service.activity.core.sql;

public class IndexModuleSQL {

	//根据城市获取首页的模块名称
	public static final String GET_INDEX_MODULE = "SELECT sm.modName as moduleName,sm.useType as useType,sm.webViewUrl as webViewUrl FROM CityIndexModule cim "
			+ "LEFT JOIN city c ON cim.cityNo = c.cityNo "
			+ "LEFT JOIN ServiceModule sm ON sm.smId = cim.moduleId WHERE cim.cityNo = ? ORDER BY sm.moduleSort ASC";
}
